 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
<%
If Session("UserID") = "" Then
%> <%
Else
response.write " "
End If
%> |
 |
 |
 |
 |
 |
 |
 |
 |
<%
If Session("UserID") = "" Then
%>
<%
Else
response.write " "
End If
%> |
 |
 |
 |
 |
 |
 |
 |
 |
 |
<%
If strProfile <> "ProfileNotFound" Then
%> <%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr ' Open database connection
strSQL = "SELECT UserID, GivCustomerID, UserStatus, WorkType, "
strSQL = strSQL & "Orientation, Profession, PracticeExpYears, "
strSQL = strSQL & "Individual, MinSize, MaxSize, UseList, "
strSQL = strSQL & "UseArchives, UseIM, UseFileStorage, "
strSQL = strSQL & "UseVideoconferencing, InternetExpYears, "
strSQL = strSQL & "Structure, TimeCommittment, Payment, "
strSQL = strSQL & "Leadership, Research, Hear, Comments, "
strSQL = strSQL & "TimeDateSubmitted, Authorised, HighestQual, "
strSQL = strSQL & "QualName, QualInstitution, InstitutionCountry, "
strSQL = strSQL & "FurtherProfQuals, SupervisionExprnceTraining, "
strSQL = strSQL & "ProfExpernceExpertse, PresentJobTitle, "
strSQL = strSQL & "WorkAddress, WorkPhoneNo, WorkPhoneCountryCode, "
strSQL = strSQL & "WorkPhoneAreaCode, ProfRegNo, ProfRegBody, "
strSQL = strSQL & "ProfRegBodyAddress, OwnSupervisorName, "
strSQL = strSQL & "OwnSupervisorContactDetails, AdditionalDetails, "
strSQL = strSQL & "FurtherInfoDate, InsuranceDetails"
strSQL = strSQL & " FROM RegisterInterest"
strSQL = strSQL & " WHERE UserID = '" & strSuppliedPID & "'"
Set rs = conn.Execute(strSQL)
If Not rs.EOF Then
strTimeDateSubmitted = rs.Fields("TimeDateSubmitted")
strAuthorised = rs.Fields("Authorised")
strGivCustomerID = rs.Fields("GivCustomerID")
strUserID = rs.Fields("UserID")
strUserStatus = rs.Fields ("UserStatus")
strWorkType = rs.Fields ("WorkType")
strOrientation = rs.Fields ("Orientation")
strProfession = rs.Fields ("Profession")
strPracticeExpYears = rs.Fields ("PracticeExpYears")
strIndividual = rs.Fields ("Individual")
strMinSize = rs.Fields ("MinSize")
strMaxSize = rs.Fields ("MaxSize")
strUseList = rs.Fields ("UseList")
strUseArchives = rs.Fields ("UseArchives")
strUseIM = rs.Fields ("UseIM")
strUseFileStorage = rs.Fields ("UseFileStorage")
strUseVideoconferencing = rs.Fields ("UseVideoconferencing")
strInternetExpYears = rs.Fields ("InternetExpYears")
strStructure = rs.Fields ("Structure")
strTimeCommittment = rs.Fields ("TimeCommittment")
strPayment = rs.Fields ("Payment")
strLeadership = rs.Fields ("Leadership")
strResearch = rs.Fields ("Research")
strHear = rs.Fields("Hear")
strComments = rs.Fields("Comments")
strHighestQual = rs.Fields("HighestQual")
strQualName = rs.Fields("QualName")
strQualInstitution = rs.Fields("QualInstitution")
strInstitutionCountry = rs.Fields("InstitutionCountry")
strFurtherProfQuals = rs.Fields("FurtherProfQuals")
strSupervisionExprnceTraining = rs.Fields("SupervisionExprnceTraining")
strProfExpernceExpertse = rs.Fields("ProfExpernceExpertse")
strPresentJobTitle = rs.Fields("PresentJobTitle")
strWorkAddress = rs.Fields("WorkAddress")
strWorkPhoneNo = rs.Fields("WorkPhoneNo")
strWorkPhoneCountry = rs.Fields("WorkPhoneCountryCode")
strWorkPhoneAreaCode = rs.Fields("WorkPhoneAreaCode")
strProfRegNo = rs.Fields("ProfRegNo")
strProfRegBody = rs.Fields("ProfRegBody")
strProfRegBodyAddress = rs.Fields("ProfRegBodyAddress")
strOwnSupervisorName = rs.Fields("OwnSupervisorName")
strOwnSupervisorContactDetails = rs.Fields("OwnSupervisorContactDetails")
strAdditionalDetails = rs.Fields("AdditionalDetails")
strFurtherInfoDate = rs.Fields("FurtherInfoDate")
strInsuranceDetails = rs.Fields("InsuranceDetails")
rs.Close ' Close recordset
Set rs = nothing ' Remove recordset
If strResearch <> "not willing to participate........" Then
strSQL = "SELECT Username, Title, Greeting, FirstName, LastName, EmailAddress,"
strSQL = strSQL & " Active, LastActive, ProfilePrivacy, IdentityPrivacy, EmailPrivacy,"
strSQL = strSQL & " Description, Gender, Occupation, SpokenLanguages, Location, Timezone,"
strSQL = strSQL & " URL1, URLDescription1, URL2, URLDescription2, URL3, URLDescription3,"
strSQL = strSQL & " PhotoLocation, PhotoApproval, PhotoWidth, PhotoHeight,"
strSQL = strSQL & " StreetAddress1, StreetAddress2, Town, County, Country, PostCode,"
strSQL = strSQL & " TelephoneNo, EmailAddress"
strSQL = strSQL & " FROM Customers"
strSQL = strSQL & " WHERE CustomerID = '" & strGivCustomerID & "'"
Set rs = conn.Execute(strSQL)
If Not rs.EOF Then ' No db record found for supplied UserID
strAddress1 = rs.Fields("StreetAddress1")
strAddress2 = rs.Fields("StreetAddress2")
strTown = rs.Fields("Town")
strCounty = rs.Fields("County")
strCountry = rs.Fields("Country")
strPostcode = rs.Fields("PostCode")
strTelephone = rs.Fields("TelephoneNo")
strEmail = rs.Fields("EmailAddress")
strUsername = LCase(rs.Fields ("Username"))
strTitle = rs.Fields ("Title")
strGreeting = rs.Fields ("Greeting")
strFirstName = rs.Fields ("FirstName")
strLastName = rs.Fields ("LastName")
strEmailAddress = rs.Fields ("EmailAddress")
strActive = rs.Fields ("Active")
strLastActive = rs.Fields ("LastActive")
strProfilePrivacy = rs.Fields ("ProfilePrivacy")
strIdentityPrivacy = rs.Fields ("IdentityPrivacy")
strEmailPrivacy = rs.Fields ("EmailPrivacy")
strDescription = rs.Fields ("Description")
strGender = rs.Fields ("Gender")
strOccupation = rs.Fields ("Occupation")
strSpokenLanguages = rs.Fields ("SpokenLanguages")
strLocation = rs.Fields ("Location")
strTimezone = rs.Fields ("Timezone")
strURL1 = rs.Fields ("URL1")
strURLDescription1 = rs.Fields ("URLDescription1")
strURL2 = rs.Fields ("URL2")
strURLDescription2 = rs.Fields ("URLDescription2")
strURL3 = rs.Fields ("URL3")
strURLDescription3 = rs.Fields ("URLDescription3")
strPhotoLocation = rs.Fields ("PhotoLocation")
strPhotoApproval = rs.Fields ("PhotoApproval")
strPhotoWidth = rs.Fields ("PhotoWidth")
strPhotoHeight = rs.Fields ("PhotoHeight")
Set rs = nothing ' Close recordset
%> |
|
<%
If strAuthorised <> "No" OR Session("UserStatus") = "researching" Then
%>
|
<%
If cstr(Session("UserID")) = cstr(strSuppliedPID) Then
%> <%
Else
If cstr(Session("UserStatus")) = cstr("researching") Then
%>
<%
Else
%> <%
End If
End If
%> |
| |
<% response.write strFirstName%> <% response.write strLastName%> <%
If Session("UserID") + 1 = strSuppliedPID + 1 Then
response.write " Welcome, " & Session("Title") & " " & Session("Firstname") & " " & Session("Lastname") & "!"
response.write "
Click on the buttons above to edit your profile or return to your homepage!
| "
Else
If Session("UserStatus") = "researching" Then
response.write "Welcome, " & Session("Title") & " " & Session("Firstname") & " " & Session("Lastname") & "!"
response.write "
In your capacity as researcher, you may click on the buttons above to grant, deny or enter into dialogue about this registrant's authorisation to access supervision on the site and participate in the research. Or you can confirm that this user's credentialling documentation has been received, return to the search page, listing those registrants who have submitted further professional details and whose authorisation is pending, or return to your homepage.
| "
End If
End If
%> | <%
If strIdentityPrivacy = "Public" AND strPhotoLocation <> "NA" AND strPhotoApproval = "Yes" Then
' Live Photo
%> 
<%
Else
%> 
<%
End If
%> |
<%
If strUserStatus <> "researching" Then
%>
Essential
Personal/Professional Details
<% response.write strTitle & " "%><% response.write strFirstName & " "%><% response.write strLastName%> has registered interest with online-supervision.net in <% response.write strUserStatus%> supervision mainly for <% response.write strWorkType%> work. <% response.write strFirstName%> works predominantly in the field of <% response.write strProfession%>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr ' Open database connection
strSQL = "SELECT ProfessionID"
strSQL = strSQL & " FROM UsersProfessions"
strSQL = strSQL & " WHERE UserID = '" & strSuppliedPID & "'"
Set rs = conn.Execute(strSQL)
If Not rs.eof Then
response.write ", and is interested in " & strUserStatus & " supervision for the practice of: "
do while not rs.eof
strProfessionID = rs.Fields("ProfessionID")
strSQL = "SELECT ProfessionName"
strSQL = strSQL & " FROM Professions"
strSQL = strSQL & " WHERE ProfessionID = '" & strProfessionID & "'"
Set rs2 = conn.Execute(strSQL)
strProfessionName = rs2.Fields("ProfessionName")
rs2.Close ' Close recordset
Set rs2 = nothing ' Remove recordset
response.write "- " & strProfessionName & "
"
rs.movenext
loop
rs.Close ' Close recordset
Set rs = nothing ' Remove recordset
response.write " "
Else
response.write "."
End If
%> The primary therapeutic orientation
in <% response.write strFirstName%>'s work is <% response.write strOrientation
strSQL = "SELECT OrientationID"
strSQL = strSQL & " FROM UserOrientations"
strSQL = strSQL & " WHERE UserID = '" & strSuppliedPID & "'"
Set rs = conn.Execute(strSQL)
If Not rs.eof Then
response.write ". " & strFirstName & " is ready to " & replace(strUserStatus,"ing","e") & " supervision with a theoretical focus as follows: "
do while not rs.eof
strOrientationID = rs.Fields("OrientationID")
strSQL = "SELECT OrientationName"
strSQL = strSQL & " FROM Orientations"
strSQL = strSQL & " WHERE OrientationID = '" & strOrientationID & "'"
Set rs2 = conn.Execute(strSQL)
strOrientationName = rs2.Fields("OrientationName")
rs2.Close ' Close recordset
Set rs2 = nothing ' Remove recordset
response.write "- " & strOrientationName & "
"
rs.movenext
loop
rs.Close ' Close recordset
Set rs = nothing ' Remove recordset
response.write " "
Else
response.write "."
End If
%> <% response.write strFirstName%>
has been practicing for <% response.write strPracticeExpYears%> years, with <% response.write strInternetExpYears%>
years experience of Internet use.
|
| Preferred Supervision Arrangements
The
minimum size <% response.write strFirstName%> would want a supervision group
to be is <% response.write strMinSize%> members, with <% response.write strMaxSize%>
as the maximum number. <%
If strIndividual <> "" Then
%> Asked if it was ideally individual rather than group supervision <% response.write strFirstName%>
was looking for, the answer was <% response.write strIndividual%>. <%
End If
%> Facilitites and tools <% response.write strFirstName%> would want to use include:
<%
If strUseList <> "" Then
response.write "- " & strUseList
End If
If strUseArchives <> "" Then
response.write "
- " & strUseArchives
End If
If strUseIM <> "" Then
response.write "
- " & strUseIM
End If
If strUseFileStorage <> "" Then
response.write "
- " & strUseFileStorage
End If
If strUseVideoconferencing <> "" Then
response.write "
- " & strUseVideoconferencing
End If
%>
The sort of supervision structure
<% response.write strFirstName%> is looking for is <% response.write strStructure%> <% response.write strFirstName%>
is personally ready to make a time commitment in the region
of <% response.write strTimeCommittment%> hours per week.
<%
If strUserStatus = "providing" Then
response.write strFirstName & " is " & strPayment
End If
%> <%
If strUserStatus = "receiving" Then
%>In terms of leadership, <% response.write strFirstName%>
prefers the idea of <% response.write strLeadership
End If
%>
|
| <%
End If
%> Detailed Professional Information <% response.write strFirstName%>
has undertaken a professional training in <%
If strQualName <> "" Then
Response.write strQualName
Else
response.write " awaiting name of qualification "
End If
%> at <%
If strHighestQual <> "" Then
Response.write strHighestQual
Else
response.write " awaiting level of qualification "
End If
%> level at <%
If strQualInstitution <> "" Then
Response.write strQualInstitution
Else
response.write " awaiting name of institution "
End If
%>, <%
If strInstitutionCountry <> "" Then
Response.write strInstitutionCountry
Else
response.write " awaiting country of institution"
End If
%> . Further professional experience and expertise
<%=strFirstname%> has acquired includes the following: <%
If strFurtherProfQuals <> "" Then
response.write strFurtherProfQuals & " "
Else
response.write "No other qualifications supplied. "
End If
If strProfExpernceExpertse <> "" Then
response.write "" & strProfExpernceExpertse & " "
Else
response.write "No details of further experience or expertise supplied. "
End If
If strUserStatus = "providing" Then
response.write "" & strSupervisionExprnceTraining & " "
End If
%> Professional registration details follow: Registration
no.: <%
If strProfRegNo <> "" Then
Response.write strProfRegNo
Else
response.write " awaiting professional registration details"
End If
%> Registration body: <%
If strProfRegBody <> "" Then
Response.write strProfRegBody
Else
response.write " awaiting professional registration body details"
End If
%> Registration body Address: <%
If strProfRegBodyAddress <> "" Then
Response.write strProfRegBodyAddress
Else
response.write " awaiting professional registration body address details"
End If
%>
Present Job Title: <%
If strPresentJobTitle <> "" Then
Response.write strPresentJobTitle
Else
response.write " awaiting curerent job title details"
End If
%> <%
If strAdditionalDetails <> "" Then
Response.write "
Additional Details: " & strAdditionalDetails
End If
%> <%
If Session("UserID") = strSuppliedPID OR Session("UserStatus") = "researching" Then
%>|
The following information is only on display to the person
whose profile this is, or if person viewing the profile is a member of the research
team...
Insurance Details: <%= strInsuranceDetails%> Work Address:
<%= strWorkAddress%> Work Phone Number: <%= strWorkPhoneCountry%> <%= strWorkPhoneAreaCode%> <%= strWorkPhoneNo%> Own Supervisor's Name: <%= strOwnSupervisorName%> Own
Supervisor's Contact Details: <%= strOwnSupervisorContactDetails%> Date Further
Professional Information was Submitted: <%= strFurtherInfoDate%> | <%
End If
response.write " Links " & strFirstName & " " & strLastName & " invites you to view: "
If strURL1 <> "NA" AND strURLDescription1 <> "NA" Then
If LCase(left (strURL1,7)) = "http://" Then
Response.Write "" & strURLDescription1 & " "
Else
Response.Write "" & strURLDescription1 & " "
End If
End If
If strURL2 <> "NA" AND strURLDescription2 <> "NA" Then
If LCase(left (strURL2,7)) = "http://" Then
Response.Write "" & strURLDescription2 & " "
Else
Response.Write "" & strURLDescription2 & " "
End If
End If
If strURL3 <> "NA" AND strURLDescription3 <> "NA" Then
If LCase(left (strURL3,7)) = "http://" Then
Response.Write "" & strURLDescription3 & " "
Else
Response.Write "" & strURLDescription3 & ""
End If
End If
Response.write ""
%> | | | <%
Else
%>
|
Sorry, <%=Session("Firstname")%>, but <%=strTitle & " " & strFirstname & " " & strLastname%>'s application to join the research project into online supervision
and use the online supervision services available here has not yet been authorised. Please
click above either on the homepage link, or click on your browser's 'BACK' button,
to return to your search to refine it, if you want to try looking for other profiles. | <%
End If
Else
%>
|
Sorry, <%=Session("Firstname")%> , but the profile corresponding to the profile ID number entered
(PID#<%=strSuppliedPID%>) can not be found.
Please click above either on the homepage
link, or click on your browser's 'BACK' button, to return to your search to refine
it, if you want to try looking for other profiles. | <%
End If
Else
response.write "
Sorry! Although you have entered a valid URL for someone "
response.write "who has registered on the online-supervision.net database, we are "
response.write "currently only able to broker supervision services for registrants who "
response.write "are willing to participate in the research project associated with."
response.write "these services. We will now e-mail the registrant in question and "
response.write "encourage them to be part of the research project. If we are "
response.write "successful we will contact you "
response.write "to let you know you can now access the profile in question."
' send e-mail to Ben
End If
Else
%>
| 
Sorry, <%=Session("Firstname")%> , but the profile corresponding to the profile ID number entered
(PID#<%=strSuppliedPID%>) can not be found.
Please click above either on the homepage
link, or click on your browser's 'BACK' button, to return to your search to refine
it, if you want to try looking for other profiles. | <%
End If
Else
%>
|
Sorry, <%=Session("Firstname")%> , but profiles can only be located with a valid profile ID number
(PID#<%=strSuppliedPID%>) in the URL entered above.
Please click above either on the
homepage link, or click on your browser's 'BACK' button, to return to your search
to refine it, if you want to try looking for other profiles. | <%
End If ' end PID test
%> |
| |
 |